﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Text;

namespace Data
{
    public class LotteryChipped_Zxgl
    {
       
            /// <summary>
            /// 主键
            /// </summary>
            private readonly string primaryKey = "id";
            /// <summary>
            /// 添加
            /// </summary>
            /// <param name="model"></param>
            /// <returns></returns>
            public long Add(Model.LotteryChipped_Zxgl model)
            {
                return new DataAccess().Add<Model.LotteryChipped_Zxgl>(model, primaryKey);
            }
            /// <summary>
            /// 修改
            /// </summary>
            /// <param name="model"></param>
            /// <returns></returns>
            public int Update(Model.LotteryChipped_Zxgl model)
            {
                return new DataAccess().Update<Model.LotteryChipped_Zxgl>(model, primaryKey);
            }
            /// <summary>
            /// 删除
            /// </summary>
            /// <param name="Id"></param>
            /// <returns></returns>
            public bool Delete(long Id)
            {
                return new DataAccess().Delete<Model.LotteryChipped_Zxgl>(Id, primaryKey);
            }
            /// <summary>
            /// 单条
            /// </summary>
            /// <param name="Id"></param>
            /// <returns></returns>
            public Model.LotteryChipped_Zxgl GetModel(long Id)
            {
                return new DataAccess().Get<Model.LotteryChipped_Zxgl>(Id, primaryKey);
            }
            public Model.LotteryChipped_Zxgl GetModelByLotteryChippedid(long LotteryChippedid)
            {
                return new DataAccess().Get<Model.LotteryChipped_Zxgl>(LotteryChippedid, "LotteryChippedid");
            }
            public Model.LotteryChipped_Zxgl GetModelBysql(string sql)
            {
                return new DataAccess().Get<Model.LotteryChipped_Zxgl>(sql);
            }
            /// <summary>
            /// 总数据数
            /// </summary>
            /// <returns></returns>
            public int GetAll_Count()
            {
                return new DataAccess().GetCount<Model.LotteryChipped_Zxgl>(primaryKey);
            }
            /// <summary>
            /// 抽取分页数据
            /// </summary>
            public List<Model.LotteryChipped_Zxgl> GetPageList_Where(int PageIndex, int PageSize, long newsclassid, out int totalCount)
            {
                string strWhere = GetSqlWhere(newsclassid);
                totalCount = new DataAccess().GetCount<Model.LotteryChipped_Zxgl>(primaryKey, strWhere);
                return new DataAccess().GetPage_List<Model.LotteryChipped_Zxgl>(PageIndex, PageSize, primaryKey, primaryKey + " desc", strWhere);
            }
            public List<Model.LotteryChipped_Zxgl> GetPageListWhere(int PageIndex, int PageSize, string sql, out int totalCount)
            {
                totalCount = new DataAccess().GetCount<Model.LotteryChipped_Zxgl>(primaryKey, sql);
                return new DataAccess().GetPage_List<Model.LotteryChipped_Zxgl>(PageIndex, PageSize, primaryKey, primaryKey + " desc", sql);
            }
            public List<Model.LotteryChipped_Zxgl> GetPageListWhere(int PageIndex, int PageSize, string lotteryQs, int lotteryType, out int totalCount)
            {
                string strWhere = GetSqlWhere(lotteryQs, lotteryType);
                totalCount = new DataAccess().GetCount<Model.LotteryChipped_Zxgl>(primaryKey, strWhere);
                return new DataAccess().GetPage_List<Model.LotteryChipped_Zxgl>(PageIndex, PageSize, primaryKey, primaryKey + " desc", strWhere);
            }
            public DataTable GetPageDT_Where(int PageIndex, int PageSize, long newsclassid, out int totalCount)
            {
                string strWhere = GetSqlWhere(newsclassid);
                totalCount = new DataAccess().GetCount<Model.LotteryChipped_Zxgl>(primaryKey, strWhere);
                return ConvertHelper<Model.LotteryChipped_Zxgl>.ConvertToDT(new DataAccess().GetPage_List<Model.LotteryChipped_Zxgl>(PageIndex, PageSize, primaryKey, primaryKey + " desc", strWhere));
            }
            public DataTable GetPageDTWhere(int PageIndex, int PageSize, int lotteryType, string lotteryQs, out int totalCount)
            {
                string strWhere = GetSqlWhere(lotteryQs, lotteryType);
                totalCount = new DataAccess().GetCount<Model.LotteryChipped_Zxgl>(primaryKey, strWhere);
                return ConvertHelper<Model.LotteryChipped_Zxgl>.ConvertToDT(new DataAccess().GetPage_List<Model.LotteryChipped_Zxgl>(PageIndex, PageSize, primaryKey, primaryKey + " desc", strWhere));
            }
            /// <summary>
            /// 拼接条件
            /// </summary>
            public string GetSqlWhere(string lotteryQs, int lotteryType)
            {
                StringBuilder sqlWhere = new StringBuilder();

                sqlWhere.Append(" 1>0");
                if (lotteryQs != "")
                {
                    sqlWhere.Append(" and LotteryOpenTime =" + lotteryQs);
                }
                if (lotteryType > 0)
                {
                    sqlWhere.Append(" and LotteryType =" + lotteryType);
                }
                return sqlWhere.ToString();
            }
            /// <summary>
            /// 拼接条件
            /// </summary>
            public string GetSqlWhere(long newsclassid)
            {
                StringBuilder sqlWhere = new StringBuilder();

                sqlWhere.Append(" 1>0");

                if (newsclassid > 0)
                {
                    sqlWhere.Append(" and LotteryType =" + newsclassid);
                }
                return sqlWhere.ToString();
            }
            /// <summary>
            /// 批删
            /// </summary>
            /// <param name="Ids"></param>
            /// <returns></returns>
            public int Drop(string Ids)
            {
                return new DataAccess().Drop<Model.LotteryChipped_Zxgl>(Ids, primaryKey);
            }
        }
}
